AdAttendArchive

EntityType | Independent
Logical Entity Name | AdAttendArchive
Default Table Name | AdAttendArchive
Logical Only | NO
Owner | dbo
Definition |
Note |

AdAttendArchive Attributes

Attribute/Logical Rolename | Domain | Datatype | NULL | Definition
AdAttendID |  | INTEGER | NO |
StudentCourseId |  | INTEGER | NO |
AdEnrollID |  | INTEGER | NO |
Date |  | DATETIME | NO |
StartTime |  | DATETIME | NO |
Attend |  | INTEGER | YES |
Absent |  | INTEGER | YES |
UnitType |  | CHAR(1) | YES |
Status |  | CHAR(1) | YES |
Type |  | CHAR(1) | YES |
Comment |  | VARCHAR(255) | YES |
Excused |  | BIT | NO |
UserID |  | INTEGER | NO |
DateAdded |  | DATETIME | NO |
DateLstMod |  | DATETIME | NO |
DateArchived |  | DATETIME | NO |
ts |  | TIMESTAMP/DATE | NO |
AdClassAttendID |  | INTEGER | YES |

AdAttendArchive Keys

Key Name | Key Type | Keys
AdAttendArchive_AdEnrollID_N_N_IDX | Inversion Entry | AdEnrollID
AdAttendArchive_AdEnrollSchedID_AdClassAttendID_N_N_IDX | Inversion Entry | StudentCourseId, AdClassAttendID
AdAttendArchive_AdClassAttendID_N_N_IDX | Inversion Entry | AdClassAttendID
AdAttendArchive_AdEnrollSchedID_Date_StartTime_U_N_IDX | Unique Constraint | StudentCourseId, Date, StartTime
AdAttendArchive_AdAttendID_U_C_IDX | PrimaryKey | AdAttendID

AdAttendArchive Relationships

Parent Relationships:

Entity Name | Type | Cardinality | Business Name | VerbPhrase | InversePhrase | Foreign Keys | Is Supertype
StudentCourse | Non-Identifying | One To Zero or More |  |  |  | StudentCourseId | NO

Child Relationships:

Entity Name | Type | Cardinality | Business Name | VerbPhrase | InversePhrase | Foreign Keys | Is Subtype

AdAttendArchive Check Constraints

Check Constraint Name | CheckConstraint

AdAttendArchive Where Used - Model Usage

Mapped Object | Is User Defined? | Denormalization Mappings | Description | Bound Attachments
Logical dbo.AdAttendArchive | NO |  |  |
Physical (Microsoft SQL Server) dbo.AdAttendArchive | NO |  |  |

AdAttendArchive Where Used - Submodel Usage

Model | Submodel Usage
Logical | Main Model
Physical (Microsoft SQL Server) | Main Model
Physical (Microsoft SQL Server) | Academic Records

AdAttendArchive Data Movement Rules

Name | Type | Rule Text/Value